{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["FUNCIONARI","Vacances","valors func","calcul dies"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":11,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"FUNCIONARI","index":0,"n_rows":81,"n_cols":8,"rows_kept":81,"cut":false,"hidden":false,"merged":[[7,5,7,6],[61,1,61,2],[31,6,31,7],[45,6,45,7],[52,6,52,7],[12,1,12,5],[31,2,31,5],[12,6,12,7],[1,2,1,5],[3,3,3,5],[4,5,4,6],[5,5,5,6],[6,5,6,6],[75,1,75,5],[8,5,8,6],[11,5,11,6],[10,1,10,7],[9,5,9,6]]}
[]
[null,"NOM"]
[null,"PERFIL",null,null,null,null,"mesos","dies"]
[null,"DEDICACIÓ",null," Periode",null,null,{"$f":"IF(C6=0,0,SUM(E65))","v":0},{"$f":"IF(C6=0,0,SUM(F65))","v":0}]
[null,"INICI CONTRACTE",null,null,null,"Nº TRIENNIS GRUP A1"]
[null,"FI CONTRACTE",null,null,null,"Nº TRIENNIS GRUP A2"]
[null,"Grup: ","1900-01-03",null,null,"Nº TRIENNIS GRUP C1"]
[null,"Complement de destí",null,null,null,"Nº TRIENNIS GRUP C2"]
[null,"Complement específic",null,null,null,"IMPORT MENSUAL TRIENNIS",null,{"$f":"((H5*'valors func'!H12)+('valors func'!H13*(H6)+('valors func'!H14*(H7)++('valors func'!H15*(H8))*(C4/35))))","v":0}]
[null,null,null,null,null,"IMPORT EXTRAS TRIENNIS ANUAL",null,{"$f":"((H5*'valors func'!I12)+('valors func'!I13*(H6)+('valors func'!I14*(H7)++('valors func'!I15*(H8))*(C4/35))))*2","v":0}]
[null,"Proposta segons el perfil seleccionat, cal introduir-ho manualment, celdes C7, C8 i C9"]
[null,"Grup: ",{"$f":"'valors func'!F27","v":"A1 o A2"},"comp.destí",{"$f":"'valors func'!G27","v":22},"comp.específic",null,{"$f":"'valors func'!H27","v":"O"}]
[null,"COST MENSUAL",null,null,null,null,"COST ANUAL"]
[null,"Retribucions:      ",{"$f":"SUM(C15:C19)","v":0},null,null,null,"Retribucions:      ",{"$f":"C14*12","v":0}]
[null,"Sou",{"$f":"('valors func'!F20)*C4/35","v":0},null,null,null,"Sou",{"$f":"C15*12","v":0}]
[null,"Complement de destí",{"$f":"('valors func'!F22*C4/35)","v":0},null,null,null,"Complement de destí",{"$f":"C16*12","v":0}]
[null,"Complement específic",{"$f":"('valors func'!F24*C4/35)","v":0},null,null,null,"Complement específic",{"$f":"C17*12","v":0}]
[null,"IPC Destí PAS",{"$f":"('valors func'!G22*C4/35)","v":0},null,null,null,"IPC Destí PAS",0]
[null,"IPC Sou PAS",{"$f":"('valors func'!H20*C4/35)","v":0},null,null,null,"IPC Sou PAS",0]
[]
[null,"Prorrata  extres SOU",{"$f":"'valors func'!G20*2/12*C4/35","v":0},null,null,null,"Extres SOU",{"$f":"SUM(C21*12)","v":0}]
[null,"Prorrata  extres COM.DESTÍ",{"$f":"((C16*2)/12)","v":0},null,null,null,"Extres COM.DESTÍ",{"$f":"SUM(C22*12)","v":0}]
[null,"Prorrata  extres COM.ESPC.",{"$f":"C17*2/12","v":0},null,null,null,"Extres COM.ESPC.",0]
[null,"Prorrata  extres TRIENNIS",{"$f":"H10/12","v":0},null,null,null,"Extres TRIENNIS",{"$f":"SUM(C24*12)","v":0}]
[null,"TOTAL PRORRATA ",{"$f":"SUM(C21:C24)","v":0},null,null,null,"TOTAL PRORRATA",{"$f":"SUM(C25*12)","v":0}]
[]
[null,"Triennis: ",{"$f":"H9","v":0},null,null,null,"Triennis: ",{"$f":"C27*12","v":0}]
[]
[null,"TOTAL RETRIB.",{"$f":"SUM(C14+C25+C27)","v":0},null,null,null,"TOTAL RETRIB.",{"$f":"SUM(H14+H25+H27)","v":0}]
[null,"Quota patronal",{"$f":"IF(C29>'valors func'!H2,'valors func'!H2*'valors func'!H3,C29*'valors func'!H3)","v":0},null,null,null,"Quota patronal",{"$f":"IF(C29>'valors func'!H2,C30*12,H29*'valors func'!H3)","v":0}]
[null,"TOTAL COST",{"$f":"SUM(C29:C30)","v":0},null,null,null,"TOTAL COST",{"$f":"SUM(H29:H30)","v":0}]
[null,"COST PERIODE ",{"$f":"CONCATENATE(\" (\",DAY(C5),\"/\",MONTH(C5),\"/\",YEAR(C5),\"-\",DAY(C6),\"/\",MONTH(C6),\"/\",YEAR(C6),\")\")","v":" (0/1/1900-0/1/1900)"},null,null,null,"COST TOTAL VINCULACIÓ"]
[null,"Retribucions:",{"$f":"IF(C14=0,0,C14*(E65+(F65/30)))","v":0},null,{"$f":"IF( (E67+F67+E68+F68)=0,0,C33)","v":0},null,"Retribucions:",{"$f":"IF(C14=0,0,C14*(E64+F64/30))","v":0}]
[]
[null,"TOTAL EXTRES:",{"$f":"SUM(C36:C37)","v":0},null,{"$f":"SUM(E36:E37)","v":0},null,"TOTAL EXTRES:",{"$f":"SUM(H36:H37)","v":0}]
[null,"Extra  juny",{"$f":"IF(C25=0,\" \",C25/2*(E65+(F65/30)))","v":" "},null,{"$f":"IF((E67+F67+E68+F68)=0,0,C25/2*(E67+F67/30)+C36)","v":0},null,"Extra  juny",{"$f":"IF(C25=0,0,C25/2*(E64+F64/30))","v":0}]
[null,"Extra desembre",{"$f":"IF(C25=0,\" \",(C25/2)*(E65+F65/30))","v":" "},null,{"$f":"IF((E67+F67+E68+F68)=0,0,C25/2*(E68+F68/30)+C37)","v":0},null,"Extra desembre",{"$f":"IF(C25=0,0,C25/2*(E64+F64/30))","v":0}]
[]
[null,"Triennis: ",{"$f":"IF(C27=0,0,C27*(E65+F65/30))","v":0},null,{"$f":"IF((E67+F67+E68+F68)=0,0,C39)","v":0},null,"Triennis: ",{"$f":"IF(C27=0,0,C27*(E64+F64/30))","v":0}]
[]
[null,"TOTAL RETRIB.",{"$f":"IF(C33=0,0,SUM(C33+C35+C39))","v":0},null,{"$f":"SUM(E33+E35+E39)","v":0},null,"TOTAL RETRIB.",{"$f":"SUM(H33+H35+H39)","v":0}]
[null,"Quota patronal",{"$f":"IF(C30=0,0,C30*(E65+(F65/30)))","v":0},null,{"$f":"IF((E67+F67+E68+F68)=0,0,C42)","v":0},null,"Quota patronal",{"$f":"H41*#REF!","v":{"$error":"#REF!"}}]
[null,"TOTAL COST",{"$f":"SUM(C41:C42)","v":0},null,{"$f":"SUM(E41:E42)","v":0},null,"TOTAL COST",{"$f":"SUM(H41:H42)","v":{"$error":"#REF!"}}]
[]
[]
[null,"COST AMB MARGE  PERIODE ACTUAL",null,null,null,null,"Cost amb  marge TOTAL VINCULACIÓ"]
[null,"Marge",0.01]
[null,null,null,null,"Amb arrossegament"]
[null,"Import L1",{"$f":"SUM(#REF!)+(#REF!*$C$47)","v":{"$error":"#REF!"}},"Import L1",{"$f":"SUM(#REF!)+(#REF!*$C$47)","v":{"$error":"#REF!"}},null,"Import L1",{"$f":"SUM(#REF!)+(#REF!)*$C$47","v":{"$error":"#REF!"}}]
[null,"Import L2",{"$f":"SUM(#REF!+#REF!*$C$47)","v":{"$error":"#REF!"}}]
[null,"                                    TOTAL    ",{"$f":"SUM(C49:C50)","v":{"$error":"#REF!"}},"Import L2",{"$f":"SUM(#REF!+#REF!*$C$47)","v":{"$error":"#REF!"}},null,"Import L2",{"$f":"SUM(#REF!+#REF!*$C$47)","v":{"$error":"#REF!"}}]
[]
[null,"Cost amb marge i retallada  PERIODE ACTUAL"]
[null,null,"Retribucions","Quota patronal"]
[null,"Import aprox.Retallada 2014",{"$f":"(C25/2)*(E70+F70/30)","v":0},{"$f":"(C55*#REF!)","v":{"$error":"#REF!"}},null,null,"Retallades anteriors a 2014 "]
[null,null,"Sense arrossegament",null,"Amb arrossegament"]
[null,"Import L1",{"$f":"SUM(#REF!-C55)+(#REF!-C55)*$C$47","v":{"$error":"#REF!"}},"Import L1",{"$f":"IF((E67+F67+E68+F68)=0,0,(#REF!-C55)+(#REF!-C55)*$C$47)","v":0},null,"Import L1",{"$f":"SUM(#REF!-H55-C55)+(#REF!-H55-C55)*$C$47","v":{"$error":"#REF!"}}]
[null,"Import L2",{"$f":"SUM(#REF!-D55)+(#REF!-D55)*$C$47","v":{"$error":"#REF!"}},"Import L2",{"$f":"IF((E67+F67+E68+F68)=0,0,(#REF!-D55)+(#REF!-D55)*$C$47)","v":0},null,"Import L2",{"$f":"SUM(#REF!-D55+(#REF!-D55)*$C$47)","v":{"$error":"#REF!"}}]
[null,"TOTAL",{"$f":"SUM(C57:D58)","v":{"$error":"#REF!"}},"TOTAL",{"$f":"SUM(E57:E58)","v":0},null,"TOTAL AMB RETALLADES",{"$f":"SUM(H57:H58)","v":{"$error":"#REF!"}}]
[null,"FONS CONTINGÈNCIA",{"$f":"SUM((#REF!-C55)+(#REF!))*3%","v":{"$error":"#REF!"}},"(sense marge)",null,null,"(INCLOSES ANTERIORS 2014)"]
[]
[null,"MERITACIÓ ARROSEGAMENT PAGUES"]
[null,null,"DATA INICI","DATA FI","Nº MESOS","Nº DIES"]
[null,"TOTAL VINCULACIÓ",null,null,null,{"$f":"IF((D64-C64)>0,'calcul dies'!N5,\" \")","v":" "}]
[null,"PRORROGA",{"$f":"IF(C5=0,\" \",C5)","v":" "},{"$f":"IF(C6=0,\" \",C6)","v":" "},{"$f":"IF((D65-C65)>0,'calcul dies'!L10,\"ERROR DATES\")","v":{"$error":"#VALUE!"}},{"$f":"IF((D65-C65)>0,'calcul dies'!N10,\" \")","v":{"$error":"#VALUE!"}}]
[null,"MERITEN",null,"DATA FI","NºMESOS","Nº DIES"]
[null,"de 01/07 a 30/06",null,{"$f":"IF(H5=0,\" \",(H5)-1)","v":" "},{"$f":"IF(C67=0,0,IF((D67-C67)>366,\"ERROR DATA\",IF((D67-C67)>0,'calcul dies'!L15,\"ERR0R DATA \")))","v":0},{"$f":"IF(C67=0,0,IF((D67-C67)>366,\" \",IF((D67-C67)>0,'calcul dies'!N15,\" \")))","v":0}]
[null,"de 01/01 a 31/12",null,{"$f":"IF(H5=0,\" \",(H5)-1)","v":" "},{"$f":"IF(C68=0,0,IF((D68-C68)>366,\"ERROR DATA\",IF((D68-C68)>0,'calcul dies'!L20,\"ERR0R DATA \")))","v":0},{"$f":"IF(C68=0,0,IF((D68-C68)>366,\" \",IF((D68-C68)>0,'calcul dies'!N20,\" \")))","v":0}]
[null,"Indemnització RD",null,{"$f":"IF(H5=0,\" \",(H5)-1)","v":" "},{"$f":"IF(C69=0,0,IF((D69-C69)>366,\"ERROR DATA\",IF((D69-C69)>0,'calcul dies'!L25,\"ERR0R DATA \")))","v":0},{"$f":"IF(C69=0,0,IF((D69-C69)>366,\"ERROR DATA\",IF((D69-C69)>0,'calcul dies'!N25,\" \")))","v":0}]
[null,"Període treballat al 2014",null,{"$f":"IF(YEAR(H5)>2014,DATE(2014,12,31),IF(H5<>0,H5,\" \"))","v":" "},{"$f":"IF(C70=0,0,IF((D70-C70)>366,\"ERROR DATA\",IF((D70-C70)>0,'calcul dies'!L30,\"ERR0R DATA \")))","v":0},{"$f":"IF(C70=0,0,IF((D70-C70)>366,\"ERROR DATA\",IF((D70-C70)>0,'calcul dies'!N30,\" \")))","v":0}]
[]
[]
[]
[]
[]
[null,"COST AMB MARGE  PERIODE ACTUAL"]
[null,"Marge"]
[]
[null,"TOTAL RETRIB.",{"$f":"SUM(C41)+(C41*C77)","v":0}]
[null,"Quota patronal",{"$f":"SUM(C42)+(C42*C77)","v":0}]
[null,"TOTAL COST",{"$f":"SUM(C79:C80)","v":0}]

{"sheet":"Vacances","index":1,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["Càlcul dies de vacances"]
[]
[null,"Inici període. Ha de ser posterior o igual que el darrer 1 de setembre"]
[null,"Fi període. La data de finalització del contracte"]
[]
[null,"Dies d'absència en el període: Vagues, permisos sense sou, etc…"]
[]
[null,"Dies Gaudits de vacances en el període"]
[]
[{"$f":"ROUNDUP(((A5-A4-A7)*22/365)-A9,0)","v":0},"DIES QUE PERTOQUEN DE VACANCES"]
["DIES HABILS MIRAR SEMPRE CALENDARI"]
["1,8 DIES HÀBILS PER MES TREBALLAT. AIXÒ CORRESPON ALS 22 DIES HÀBILS PER ANY TREBALLAT."]

{"sheet":"valors func","index":2,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":true,"merged":[[56,4,56,5]]}
["gestio_uaslr","grup","complement destinació","complement específic"]
["INTERÍ  TGN1F","A1 o A2",22,"O",null,null,"Base màx.cotizzció",4139.3999999999996]
["INTERÍ  TGN2F","A1 O A2 ",22,"R",null,null,"% SS",0.312]
["INTERÍ  TGN3F","A2 o C1",20,"T",null,null,null,0.307]
["INTERÍ OPERATIU N1F","C2",16,"Z",null,null,null,{"$f":"H3-H4","v":5.0000000000000044E-3}]
["INTERÍ OPERATIU N2F","C2",14,"Z"]
["INTERÍ TSN1F","C1 o C2",18,"V"]
["INTERÍ TSN2F","C1 o C2",16,"X"]
[]
[]
["Grups","Sou mes","PE sou","IPC Sou  mes",null,"Trienni mes","IPCTri mes","TOTAL TRIENNIS","PE triennis"]
["A1",1238.68,764.37,41.39,"A1",47.67,2.38,{"$f":"SUM(F12:G12)","v":50.050000000000004},29.43,null,{"$f":"(B11:B12*2.25%)+B12","v":1266.5503000000001}]
["A2",1071.06,781.15,35.1,"A2",38.880000000000003,1.92,{"$f":"SUM(F13:G13)","v":40.800000000000004},28.35,null,{"$f":"(B12:B13*2.25%)+B13","v":1095.15885}]
["C1",804.19,695.06,26.18,"C1",29.43,1.45,30.88,25.41,null,822.28427500000009]
["C2",669.3,663.2,21.42,"C2",20.03,0.96,20.990000000000002,19.829999999999998,null,684.35924999999997]
[]
[]
["C.DEST.","Nv mes","IPC PAS DESTÍ"]
["28             ",929.71,29.33,null,"GRUP","Sou mes","PE sou","IPC Sou  mes"]
["27             ",888.86,28.05,null,1,{"$f":"CHOOSE('valors func'!E20,B12,B13,B14,B15)","v":1238.68},{"$f":"CHOOSE('valors func'!E20,C12,C13,C14,C15)","v":764.37},{"$f":"CHOOSE('valors func'!E20,D12,D13,D14,D15)","v":41.39},null,null,{"$f":"G20/35","v":21.839142857142857},{"$f":"K20*20","v":436.78285714285715}]
["26             ",779.83,24.63,null,"C. DESTÍ","Nv mes","IPC PAS DESTÍ",null,null,null,null,{"$f":"L20*2","v":873.56571428571431}]
["24             ",651.05999999999995,20.56,null,5,{"$f":"CHOOSE('valors func'!E22,B19,B20,B21,B22,B23,B24,B25,B26,B27)","v":569.45000000000005},{"$f":"CHOOSE('valors func'!E22,C19,C20,C21,C22,C23,C24,C25,C26,C27)","v":18}]
["22             ",569.45000000000005,18,null,"C,ESP","CE mes"]
["20             ",491.11,15.53,null,5,{"$f":"CHOOSE('valors func'!E24,B32,B33,B34,B35,B36,B37,B38,B39,B40,B41,B42)","v":1232.5}]
["18             ",440.97,13.95]
["16             ",390.85,12.37,null,"gestio_uaslr","grup","complement destinació","complement específic"]
["14             ",340.7,10.78,null,1,{"$f":"CHOOSE(E27,B2,B3,B4,B5,B6,B7,B8)","v":"A1 o A2"},{"$f":"CHOOSE(E27,C2,C3,C4,C5,C6,C7,C8)","v":22},{"$f":"CHOOSE(E27,D2,D3,D4,D5,D6,D7,D8)","v":"O"}]
[]
[]
[]
["C.ESP.","CE mes"]
["C             ",2293.34]
["F             ",2027.76]
["I             ",1715.98]
["L             ",1390.92]
["O             ",1232.5]
["R             ",1090.1600000000001]
["S",939.11]
["T             ",900.55]
["V             ",809.45]
["X             ",762.41]
["Z             ",624.16]
[]
[]
[]
["Taules actualitzades","2022-02-01"]
[]
["Grup/subgrup","Sou","IPC Sou","Triennis","IPC Triennis",null,null,"Grup/subgrup","Sou anual\n(inclou pagues extres)","Sou paga extra JUNY i DES","IPC Sou","Triennis anual (inclou pagues extres)","Triennis paga extra JUNY i DES","IPC Triennis"]
["A/A1",1238.68,41.39,47.67,2.38,null,null,"A/A1",16392.900000000001,764.37,496.68,630.9,29.43,28.56]
["B/A2",1071.06,35.1,38.880000000000003,1.92,null,null,"B/A2",14415.019999999999,781.15,421.20000000000005,523.2600000000001,28.35,23.04]
["C/C1",804.19,26.18,29.43,1.45,null,null,"C/C1",11040.400000000001,695.06,314.15999999999997,403.97999999999996,25.41,17.399999999999999]
["D/C2",669.3,21.42,20.03,0.96,null,null,"D/C2",9358,663.2,257.04000000000002,280.02,19.829999999999998,11.52]
["E",null,null,15.08,0.76,null,null,"E",null,null,null,211.12,15.08,9.120000000000001]
[]
[]
[]
[null,"C. Destí","IPC Destí",null,"C. Específic"]
["28             ",929.71,29.33,null,2293.34,"C"]
["27             ",888.86,28.05,null,2027.76,"F"]
["26             ",779.83,24.63,null,1715.98,"I"]
["24             ",651.05999999999995,20.56,null,1390.92,"L"]
["22             ",569.45000000000005,18,null,1232.5,"O"]
["20             ",491.11,15.53,null,1090.1600000000001,"R"]
["18             ",440.97,13.95,null,939.11,"S"]
["16             ",390.85,12.37,null,900.55,"T"]
["14             ",340.7,10.78,null,809.45,"V"]
[null,null,null,null,762.41,"X"]
[null,null,null,null,624.16,"Z"]

{"sheet":"calcul dies","index":3,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":true,"merged":[[22,4,22,13],[27,4,27,13],[0,0,0,13],[2,4,2,13],[7,4,7,13],[12,4,12,13],[17,4,17,13]]}
["CALCULS DIES LABORALS NO TOPATS"]
[]
["MERITACIÓ ARROSEGAMENT PAGUES LABORALS NO TOPATS",null,null,null,"CÀLCUL DIES VINVULACIÓ"]
[null,"DATA INICI","DATA FI",null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
["TOTAL VINCULACIÓ",{"$f":"FUNCIONARI!C64","v":"00:00:00"},{"$f":"FUNCIONARI!H5","v":"00:00:00"},null,"INICI VINCULACIÓ",{"$f":"DAY(B5)","v":0},{"$f":"MONTH(B5)","v":1},{"$f":"YEAR(B5)","v":1900},null,{"$f":"IF(F5>1,-1,0)","v":0},{"$f":"IF(F5=1,-M5,0)","v":0},{"$f":"IF(H5=H6,G6-G5+1,13-G5+G6+(H6-H5-1)*12)+J5+J6","v":0},{"$f":"IF(G5=1,31-F5,IF(G5=2,28-F5,IF(G5=3,31-F5,IF(G5=4,30-F5,IF(G5=5,31-F5,IF(G5=6,30-F5,IF(G5=7,31-F5,IF(G5=8,31-F5,IF(G5=9,30-F5,IF(G5=10,31-F5,IF(G5=11,30-F5,IF(G5=12,31-F5))))))))))))+1","v":32},{"$f":"SUM(K5+M5+M6)","v":32}]
["PRORROGA",{"$f":"FUNCIONARI!C65","v":" "},{"$f":"FUNCIONARI!C6","v":"00:00:00"},null,"FI VINCULACIÓ",{"$f":"DAY(C5)","v":0},{"$f":"MONTH(C5)","v":1},{"$f":"YEAR(C5)","v":1900},null,{"$f":"IF(AND(G6=1,F6=31),0,IF(AND(G6=2,28=F6),0,IF(AND(G6=3,31=F6),0,IF(AND(G6=4,30=F6),0,IF(AND(G6=5,31=F6),0,IF(AND(G6=6,30=F6),0,IF(AND(G6=7,31=F6),0,IF(AND(G6=8,31=F6),0,IF(AND(G6=9,30=F6),0,IF(AND(G6=10,31=F6),0,IF(AND(G6=11,30=F6),0,IF(AND(G6=12,31=F6),0,-1))))))))))))","v":-1},null,null,{"$f":"IF(AND(G6=1,F6<>31),F6,IF(AND(G6=2,28<>F6),F6,IF(AND(G6=3,31<>F6),F6,IF(AND(G6=4,30<>F6),F6,IF(AND(G6=5,31<>F6),F6,IF(AND(G6=6,30<>F6),F6,IF(AND(G6=7,31<>F6),F6,IF(AND(G6=8,31<>F6),F6,IF(AND(G6=9,30<>F6),F6,IF(AND(G6=10,31<>F6),F6,IF(AND(G6=11,30<>F6),F6,IF(AND(G6=12,31<>F6),F6,0))))))))))))","v":0}]
["MERITEN",null,"DATA FI"]
["de 01/07 a 30/06",{"$f":"FUNCIONARI!C67","v":"00:00:00"},{"$f":"FUNCIONARI!D67","v":" "},null,"CÀLCUL DIES PRÒRROGA"]
["De 01/07 a 30/06",{"$f":"FUNCIONARI!C68","v":"00:00:00"},{"$f":"FUNCIONARI!D68","v":" "},null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
["Indemnització RD",{"$f":"B5","v":"00:00:00"},{"$f":"FUNCIONARI!D69","v":" "},null,"INICI PRORROGA",{"$f":"DAY(B6)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(B6)","v":{"$error":"#VALUE!"}},{"$f":"YEAR(B6)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(F10>1,-1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F10=1,-M10,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H10=H11,G11-G10+1,13-G10+G11+(H11-H10-1)*12)+J10+J11","v":{"$error":"#VALUE!"}},{"$f":"IF(G10=1,31-F10,IF(G10=2,28-F10,IF(G10=3,31-F10,IF(G10=4,30-F10,IF(G10=5,31-F10,IF(G10=6,30-F10,IF(G10=7,31-F10,IF(G10=8,31-F10,IF(G10=9,30-F10,IF(G10=10,31-F10,IF(G10=11,30-F10,IF(G10=12,31-F10))))))))))))+1","v":{"$error":"#VALUE!"}},{"$f":"SUM(K10+M10+M11)","v":{"$error":"#VALUE!"}}]
["Període treballat al 2014",{"$f":"FUNCIONARI!C70","v":"00:00:00"},{"$f":"FUNCIONARI!D70","v":" "},null,"FI VINCULACIÓ",{"$f":"DAY(C6)","v":0},{"$f":"MONTH(C6)","v":1},{"$f":"YEAR(C6)","v":1900},null,{"$f":"IF(AND(G11=1,F11=31),0,IF(AND(G11=2,28=F11),0,IF(AND(G11=3,31=F11),0,IF(AND(G11=4,30=F11),0,IF(AND(G11=5,31=F11),0,IF(AND(G11=6,30=F11),0,IF(AND(G11=7,31=F11),0,IF(AND(G11=8,31=F11),0,IF(AND(G11=9,30=F11),0,IF(AND(G11=10,31=F11),0,IF(AND(G11=11,30=F11),0,IF(AND(G11=12,31=F11),0,-1))))))))))))","v":-1},null,null,{"$f":"IF(AND(G11=1,F11<>31),F11,IF(AND(G11=2,28<>F11),F11,IF(AND(G11=3,31<>F11),F11,IF(AND(G11=4,30<>F11),F11,IF(AND(G11=5,31<>F11),F11,IF(AND(G11=6,30<>F11),F11,IF(AND(G11=7,31<>F11),F11,IF(AND(G11=8,31<>F11),F11,IF(AND(G11=9,30<>F11),F11,IF(AND(G11=10,31<>F11),F11,IF(AND(G11=11,30<>F11),F11,IF(AND(G11=12,31<>F11),F11,0))))))))))))","v":0}]
[]
[null,null,null,null,"MERITACIÓ PAGA JULIOL"]
[null,null,null,null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI",{"$f":"DAY(B8)","v":0},{"$f":"MONTH(B8)","v":1},{"$f":"YEAR(B8)","v":1900},null,{"$f":"IF(F15>1,-1,0)","v":0},{"$f":"IF(F15=1,-M15,0)","v":0},{"$f":"IF(H15=H16,G16-G15+1,13-G15+G16+(H16-H15-1)*12)+J15+J16","v":{"$error":"#VALUE!"}},{"$f":"IF(G15=1,31-F15,IF(G15=2,28-F15,IF(G15=3,31-F15,IF(G15=4,30-F15,IF(G15=5,31-F15,IF(G15=6,30-F15,IF(G15=7,31-F15,IF(G15=8,31-F15,IF(G15=9,30-F15,IF(G15=10,31-F15,IF(G15=11,30-F15,IF(G15=12,31-F15))))))))))))+1","v":32},{"$f":"SUM(K15+M15+M16)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"FI",{"$f":"DAY(C8)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(C8)","v":{"$error":"#VALUE!"}},{"$f":"YEAR(C8)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(G16=1,F16=31),0,IF(AND(G16=2,28=F16),0,IF(AND(G16=3,31=F16),0,IF(AND(G16=4,30=F16),0,IF(AND(G16=5,31=F16),0,IF(AND(G16=6,30=F16),0,IF(AND(G16=7,31=F16),0,IF(AND(G16=8,31=F16),0,IF(AND(G16=9,30=F16),0,IF(AND(G16=10,31=F16),0,IF(AND(G16=11,30=F16),0,IF(AND(G16=12,31=F16),0,-1))))))))))))","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(AND(G16=1,F16<>31),F16,IF(AND(G16=2,28<>F16),F16,IF(AND(G16=3,31<>F16),F16,IF(AND(G16=4,30<>F16),F16,IF(AND(G16=5,31<>F16),F16,IF(AND(G16=6,30<>F16),F16,IF(AND(G16=7,31<>F16),F16,IF(AND(G16=8,31<>F16),F16,IF(AND(G16=9,30<>F16),F16,IF(AND(G16=10,31<>F16),F16,IF(AND(G16=11,30<>F16),F16,IF(AND(G16=12,31<>F16),F16,0))))))))))))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"MERITACIÓ PAGA DESEMBRE"]
[null,null,null,null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI",{"$f":"DAY(B9)","v":0},{"$f":"MONTH(B9)","v":1},{"$f":"YEAR(B9)","v":1900},null,{"$f":"IF(F20>1,-1,0)","v":0},{"$f":"IF(F20=1,-M20,0)","v":0},{"$f":"IF(H20=H21,G21-G20+1,13-G20+G21+(H21-H20-1)*12)+J20+J21","v":{"$error":"#VALUE!"}},{"$f":"IF(G20=1,31-F20,IF(G20=2,28-F20,IF(G20=3,31-F20,IF(G20=4,30-F20,IF(G20=5,31-F20,IF(G20=6,30-F20,IF(G20=7,31-F20,IF(G20=8,31-F20,IF(G20=9,30-F20,IF(G20=10,31-F20,IF(G20=11,30-F20,IF(G20=12,31-F20))))))))))))+1","v":32},{"$f":"SUM(K20+M20+M21)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"FI",{"$f":"DAY(C9)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(C9)","v":{"$error":"#VALUE!"}},{"$f":"YEAR(C9)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(G21=1,F21=31),0,IF(AND(G21=2,28=F21),0,IF(AND(G21=3,31=F21),0,IF(AND(G21=4,30=F21),0,IF(AND(G21=5,31=F21),0,IF(AND(G21=6,30=F21),0,IF(AND(G21=7,31=F21),0,IF(AND(G21=8,31=F21),0,IF(AND(G21=9,30=F21),0,IF(AND(G21=10,31=F21),0,IF(AND(G21=11,30=F21),0,IF(AND(G21=12,31=F21),0,-1))))))))))))","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(AND(G21=1,F21<>31),F21,IF(AND(G21=2,28<>F21),F21,IF(AND(G21=3,31<>F21),F21,IF(AND(G21=4,30<>F21),F21,IF(AND(G21=5,31<>F21),F21,IF(AND(G21=6,30<>F21),F21,IF(AND(G21=7,31<>F21),F21,IF(AND(G21=8,31<>F21),F21,IF(AND(G21=9,30<>F21),F21,IF(AND(G21=10,31<>F21),F21,IF(AND(G21=11,30<>F21),F21,IF(AND(G21=12,31<>F21),F21,0))))))))))))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"CÀLCUL DIES INDEMNITZACIÓ"]
[null,null,null,null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI",{"$f":"DAY(B10)","v":0},{"$f":"MONTH(B10)","v":1},{"$f":"YEAR(B10)","v":1900},null,{"$f":"IF(F25>1,-1,0)","v":0},{"$f":"IF(F25=1,-M25,0)","v":0},{"$f":"IF(H25=H26,G26-G25+1,13-G25+G26+(H26-H25-1)*12)+J25+J26","v":{"$error":"#VALUE!"}},{"$f":"IF(G25=1,31-F25,IF(G25=2,28-F25,IF(G25=3,31-F25,IF(G25=4,30-F25,IF(G25=5,31-F25,IF(G25=6,30-F25,IF(G25=7,31-F25,IF(G25=8,31-F25,IF(G25=9,30-F25,IF(G25=10,31-F25,IF(G25=11,30-F25,IF(G25=12,31-F25))))))))))))+1","v":32},{"$f":"SUM(K25+M25+M26)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"FI",{"$f":"DAY(C10)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(C10)","v":{"$error":"#VALUE!"}},{"$f":"YEAR(C10)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(G26=1,F26=31),0,IF(AND(G26=2,28=F26),0,IF(AND(G26=3,31=F26),0,IF(AND(G26=4,30=F26),0,IF(AND(G26=5,31=F26),0,IF(AND(G26=6,30=F26),0,IF(AND(G26=7,31=F26),0,IF(AND(G26=8,31=F26),0,IF(AND(G26=9,30=F26),0,IF(AND(G26=10,31=F26),0,IF(AND(G26=11,30=F26),0,IF(AND(G26=12,31=F26),0,-1))))))))))))","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(AND(G26=1,F26<>31),F26,IF(AND(G26=2,28<>F26),F26,IF(AND(G26=3,31<>F26),F26,IF(AND(G26=4,30<>F26),F26,IF(AND(G26=5,31<>F26),F26,IF(AND(G26=6,30<>F26),F26,IF(AND(G26=7,31<>F26),F26,IF(AND(G26=8,31<>F26),F26,IF(AND(G26=9,30<>F26),F26,IF(AND(G26=10,31<>F26),F26,IF(AND(G26=11,30<>F26),F26,IF(AND(G26=12,31<>F26),F26,0))))))))))))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"CÀLCUL DIES RETALLADA"]
[null,null,null,null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI",{"$f":"DAY(B11)","v":0},{"$f":"MONTH(B11)","v":1},{"$f":"YEAR(B11)","v":1900},null,{"$f":"IF(F30>1,-1,0)","v":0},{"$f":"IF(F30=1,-M30,0)","v":0},{"$f":"IF(H30=H31,G31-G30+1,13-G30+G31+(H31-H30-1)*12)+J30+J31","v":{"$error":"#VALUE!"}},{"$f":"IF(G30=1,31-F30,IF(G30=2,28-F30,IF(G30=3,31-F30,IF(G30=4,30-F30,IF(G30=5,31-F30,IF(G30=6,30-F30,IF(G30=7,31-F30,IF(G30=8,31-F30,IF(G30=9,30-F30,IF(G30=10,31-F30,IF(G30=11,30-F30,IF(G30=12,31-F30))))))))))))+1","v":32},{"$f":"SUM(K30+M30+M31)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"FI",{"$f":"DAY(C11)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(C11)","v":{"$error":"#VALUE!"}},{"$f":"YEAR(C11)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(G31=1,F31=31),0,IF(AND(G31=2,28=F31),0,IF(AND(G31=3,31=F31),0,IF(AND(G31=4,30=F31),0,IF(AND(G31=5,31=F31),0,IF(AND(G31=6,30=F31),0,IF(AND(G31=7,31=F31),0,IF(AND(G31=8,31=F31),0,IF(AND(G31=9,30=F31),0,IF(AND(G31=10,31=F31),0,IF(AND(G31=11,30=F31),0,IF(AND(G31=12,31=F31),0,-1))))))))))))","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(AND(G31=1,F31<>31),F31,IF(AND(G31=2,28<>F31),F31,IF(AND(G31=3,31<>F31),F31,IF(AND(G31=4,30<>F31),F31,IF(AND(G31=5,31<>F31),F31,IF(AND(G31=6,30<>F31),F31,IF(AND(G31=7,31<>F31),F31,IF(AND(G31=8,31<>F31),F31,IF(AND(G31=9,30<>F31),F31,IF(AND(G31=10,31<>F31),F31,IF(AND(G31=11,30<>F31),F31,IF(AND(G31=12,31<>F31),F31,0))))))))))))","v":{"$error":"#VALUE!"}}]